﻿--HEADER use UIA per fundBook

delete from [Analytics].[UiaEntry]
GO

alter table [Analytics].[UiaEntry]
add [FundBookId] INT NOT NULL
GO

alter table [Analytics].[UiaEntry]
add constraint [FK_UiaEntry_ToFundBookEntity] FOREIGN KEY ([FundBookId]) REFERENCES [TradingData].[FundBookEntity](Id)
GO

insert into [Analytics].[UiaEntry]
select '2000-01-01' as ProcessedDate, '2000-01-01' as Timestamp, Id as FundBookId from [TradingData].[FundBookEntity]
GO

